package com.quan.junit.easypoi;

import java.io.File;
import java.util.List;

import org.junit.Test;

import com.quan.system.common.dto.excel.SystemEmployeeImportExcel;

import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ImportParams;

public class EmployeeImport {

	@Test
	public void test() {
		try {
			ImportParams params = new ImportParams();
			List<SystemEmployeeImportExcel> result = ExcelImportUtil.importExcel(
					new File(FileUtilTest.getWebRootPath("import/人员.xlsx")), SystemEmployeeImportExcel.class, params);

			result.forEach(item -> {
				System.out.println(item);
			});

		} catch (Exception e) {
		}
	}

}
